Database link is a named schema object that describes a path from one database to another and are implicitly used when a reference is made to a global object name in a distributed database. After you have created a database link, you can use it to refer to tables and views on the other database.
Just simply click ->
Database Link
to open an object pane for Database Link. A control-click
displays the popup menu or using the object pane toolbar below, allowing you
to create new and delete the selected database link.
Create Database Link
To create a new database link
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Database Link from the popup menu.
- Edit database link properties on the appropriate tabs of the Database Link Designer.
Delete Database Link
To delete a database link
- Select the database link for deleting in the object pane.
- Control-click and select the Delete Database Link
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Database Link Information
To achieve a database link information
- Select the database link in the object pane.
- Choose View -> Object Information in the main menu to view the Object Information.
or - Click the
from the object pane toolbar.